<?php 
return [
	'recycling_bags' => [
		'day' => "SELECT COUNT(*) as totle FROM recycling_bags WHERE date_format(created_at,'%Y-%m-%d') = date_format(DATE_ADD(now(),Interval ? day),'%Y-%m-%d')",

		'week' => "SELECT COUNT(*) as totle FROM recycling_bags WHERE YEARWEEK(date_format(created_at,'%Y-%m-%d')) = YEARWEEK(DATE_ADD(now(),Interval ? week))",

		'month' => "SELECT COUNT(*) as totle FROM recycling_bags WHERE date_format(created_at,'%Y-%m') = date_format(DATE_ADD(now(),Interval ? month),'%Y-%m')",

		'year' => "SELECT COUNT(*) as totle FROM recycling_bags WHERE YEAR(date_format(created_at,'%Y-%m-%d')) = YEAR(DATE_ADD(now(),Interval ? year))"
	]
];